Oracle数据库查询表空间位置、创建表空间、创建用户以及数据库导入 |
您所在的位置:网站首页 › oracle 数据库 表空间 › Oracle数据库查询表空间位置、创建表空间、创建用户以及数据库导入 |
-查询数据库表空间位置: select tablespace_name,file_id,bytes/1024/1024,file_name from dba_data_files order by file_id;
-创建数据库临时表空间: create temporary tablespace ERP_TEMP tempfile '/home/oracle/app/oracle/oradata/helowin/ERP_TEMP.dbf' size 1024m autoextend on next 500m maxsize unlimited extent management local;-创建数据库表空间: create tablespace FKS_DATA_TBS datafile '/home/oracle/app/oracle/oradata/helowin/FKS_DATA_TBS.dbf' size 1024m autoextend on next 500m maxsize unlimited extent management local;-创建用户及授权: -- Create the user create user user01 identified by user01 default tablespace FKS_DATA_TBS temporary tablespace ERP_TEMP profile DEFAULT quota unlimited on FKS_DATA_TBS; -- Grant/Revoke object privileges grant read, write on directory SYS.DATA_PUMP_DIR to user01; -- Grant/Revoke role privileges grant connect to user01; grant dba to user01; grant resource to user01; -- Grant/Revoke system privileges grant create synonym to user01; grant create view to user01; grant unlimited tablespace to user01;imp方式导入用户: imp user01/[email protected]:1521/Oracle fromuser=user touser=user01 file="D:\Temp\user.dmp" log="D:\Temp\toUser01.dmp"数据库导出导入参考:https://blog.csdn.net/weixin_45964650/article/details/115213095 |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |